Open topic with navigation

Work Item Burn Down iCube

Work Item Burn Down iCube enables you to create reports to track team velocity in a given iteration. Using this iCube, you can create graphs to track the number of work items left to be addressed at the end of an iteration.

Attributes

Expand this link to view the list of attributes available as part of the Work Item Burn Down iCube:

Attributes	Description
Calendar Date	Gregorian calendar date displayed in the format 'M/D/YYYY'
Calendar Month	Gregorian calendar month displayed in the format 'Mon YYYY'
Calendar Quarter	Gregorian calendar quarter displayed in the format 'Q# YYYY'
Calendar Week	Gregorian calendar week displaying the week number. For example, W21, W22.
Calendar Year	Gregorian calendar year displayed in the format YYYY
Date	Date on which the status of the Work Item moved to 'Created', 'In Progress', 'Resolved', or 'Completed'
Day of Month	Day of month between 1 and 31
Day of Week	Day of week
Day of Year	Day of the year between 1 to 366
Event Type	Indicates the event for which the burn down chart is being generated. For example, Burn Down, Scope Change, or so on.
Iteration	Iteration to which this work item is associated
Iteration Actual End Date	Date on which the iteration was closed
Iteration Planned End Date	Date on which the iteration is expected to end
Iteration Start Date	Date on which the iteration started
Lagging Count of Days	Count of number of days since the first data record till current day
Lagging Count of Months	Count of number of months since the first data record till current month
Lagging Count of Quarters	Count of number of quarters since the first data record till current quarter
Lagging Count of Weeks	Count of number of weeks since the first data record till current week
Lagging Count of Years	Count of number of years since the first data record till current year
Project	Project to which the Work Item is associated
Work Item	Work Item refers to an issue that represents work to be completed. Work items can be of various types, such as task, enhancement, bug, epic, and so on
Work Item Number	Unique identifier for the Work Item

Metrics

Expand this link to view the list of metrics available as part of the Work Item Burn Down iCube:

Metric Name	Description	Formula	Expected Value
business value added	Business value of the work item which is added to the Iteration after iteration has started	Sum([business value added])	0 or >0
business value removed	Business value of the work item which is removed during the iteration	Sum([business value removed])	0 or >0
business value reopened	Business value of the work item which is reopened during the iteration	Sum([business value reopened])	0 or >0
business value resolved	Business value of the work item which is resolved during the iteration	Sum([business value resolved])	0 or >0
estimate added	Estimate of the work Item which is added to the Iteration after iteration has started	Sum([estimate added])	0 or >0
estimate removed	Estimate of the work Item which is removed during the iteration	Sum([estimate removed])	0 or >0
estimate reopened	Estimate of the work Item which is reopened during the iteration	Sum([estimate reopened])	0 or >0
estimate resolved	Estimate of the work Item which is resolved during the iteration	Sum([estimate resolved])	0 or >0
is added count	Count of work Item which is added to the Iteration after iteration has started	Sum([is added count]){~+}	0 or >0
is removed count	Count of work Item which is removed during the iteration	Sum([is removed count])	0 or >0
is reopened count	Count of work Item which is reopened during the iteration	Sum([is reopened count])	0 or >0
is resolved count	Count of work Item which is resolved during the iteration	Sum([is resolved count])	0 or >0
Remaining Business Value	Business value of work item remaining at the end of each day	Sum ([Remaining Business Value Count])	0 or >0
Remaining Estimate Value	Estimate value of work item remaining at the end of each day	Sum ([Remaining Estimate Count])	0 or >0
Remaining Story Points	Story point of work item remaining at the end of each day	Sum ([Remaining Story Points Count])	0 or >0
Remaining Work Items	Count of work item remaining at the end of each day	Sum ([Remaining Work Item Count])	0 or >0
story points added	Story Point of the work Item which is added to the Iteration after iteration has started	Sum([story points added])	0 or >0
story points removed	Story Point of the work Item which is removed during the iteration	Sum([story points removed])	0 or >0
story points reopened	Story Point of the work Item which is reopened during the iteration	Sum([story points reopened])	0 or >0
story points resolved	Story Point of the work Item which is resolved during the iteration	Sum([story points resolved])	0 or >0